SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505820 LIMIT 1 [ RunTime:0.002403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505820 [ RunTime:0.001176s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (382879,604276,193770,555133,194959,655623,446686,7661,391717,871083,179400,336613,918811,292293,831320,209621,19756,882237,328892,556568,528265,685451,338608,393244,45879,120697,520770,399903,273426,620807,871799,513321,929593,30816,602536,654108,563542,712547,593945,113690,960500,389322,727136,957514,360014,427611,423650,698807,319073,682136,590369,820048,436148,594896,378463,154986,572291,156262,748525,575710) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003660s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505820 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000600s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505820 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]