SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001480s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504479 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504479 [ RunTime:0.002303s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1011201,1024692,645000,590194,930908,554371,183840,2741,728308,745835,525320,29596,787232,784800,479912,813899,826032,126499,68130,430885,25564,49212,943692,376157,876398,544755,448615,263861,439801,4507,593141,270849,566484,789322,525114,113857,539658,212034,999904,237497,58482,109374,781449,342848,50985,362953,736154,692396,194514,211955,489103,843993,239167,554641,639810,964526,863442,434367,712052,231251) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504479 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504479 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]