SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 235808 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 235808 [ RunTime:0.002749s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (605903,443403,302892,239506,118472,337661,196401,1016882,31301,839870,66611,787829,767846,247843,827505,73591,373457,714966,819402,30414,931024,524911,174233,887177,77225,671797,519771,295317,434177,506570,166558,1005662,1521,566365,115672,826894,748699,425837,853534,611115,524624,851807,752170,271813,685337,248366,942351,835323,1011479,298898,871503,445159,420112,696347,653185,1003671,308052,208137,316613,812989) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 235808 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001869s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 235808 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]