SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 4880 LIMIT 1 [ RunTime:0.001174s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4880 [ RunTime:0.001601s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (417362,978943,905230,866706,467697,911547,336822,65345,337147,976707,443642,245873,599807,379292,548566,1019266,1000062,461165,408324,327709,190747,351586,216696,952445,460100,702593,138296,909952,329533,86419,626508,298489,373692,858596,653583,972585,818308,889789,455731,17442,310329,783083,932413,826706,573445,737457,21519,12785,377326,175484,857736,950754,53147,35355,441689,691355,404939,802560,183962,91131) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4880 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4880 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]