SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001389s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 631871 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 631871 [ RunTime:0.002329s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (694120,404399,123841,654174,76761,932270,670909,169368,347745,412092,3928,838594,392632,861019,336351,813449,674134,845170,867429,767923,205853,1045296,298088,712262,400036,903236,521202,69964,650011,859159,98877,439412,376672,392751,988909,496961,388818,737023,553290,457830,565507,548405,154209,764325,404730,270990,813728,1026654,866400,839135,955202,595858,904209,847594,1000484,471424,41439,361357,331195,1031388) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 631871 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 631871 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000625s ]