SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001302s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023236 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023236 [ RunTime:0.001748s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (50040,927305,409552,882712,196952,737001,468181,2719,882745,273169,552389,867544,383633,125583,457381,15454,554862,513640,391885,936037,866787,754147,785928,175056,174458,673064,605549,166842,689058,168176,37942,24731,84626,144017,81544,64268,397479,893339,234686,50428,717133,69373,549395,75961,328548,533437,833975,710709,813932,948688,323587,968751,731105,789175,487968,837440,497373,303381,620614,469726) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023236 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000741s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023236 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]