SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038816 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038816 [ RunTime:0.001569s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (630172,578743,999840,147539,325493,700847,965972,417651,229605,858394,866742,1041410,795847,1040583,898133,417459,222912,24550,338226,317292,257238,48904,149642,148522,19684,709871,570770,398709,70883,203102,669742,766066,947926,412898,495235,942251,856523,106941,5121,557584,423157,823242,581746,463501,1038872,178997,549768,329710,458963,448525,605670,161504,1027355,649823,316814,469920,313388,91648,967623,737539) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000928s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038816 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038816 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]