SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1048673 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1048673 [ RunTime:0.001771s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (358275,254355,489559,534638,5728,145418,810967,1031563,29591,171243,571833,514730,788052,51048,867217,299788,511195,15381,436737,732857,954316,638476,695714,763791,90211,536117,975228,811463,344677,565993,878632,317770,939673,376567,308147,966964,976931,740273,901917,761195,543492,387779,859945,141036,501912,588150,481757,453392,328306,844543,871883,580944,956904,114453,180857,884218,80978,171189,930859,702103) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000983s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1048673 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1048673 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000334s ]