SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001523s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401740 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401740 [ RunTime:0.001928s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (179830,66267,1017060,973286,245131,584511,1035402,487151,1032008,396664,709088,602185,74526,152392,693190,518095,340898,933931,576816,1002961,472110,851622,701401,985662,799808,404183,205757,890929,468293,382898,157585,173286,702162,956017,810064,1012582,79275,149011,590371,147047,697903,903023,257873,454623,478677,322171,360783,730582,496235,28852,987219,480243,346675,628620,782018,527146,344321,7491,220302,748629) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001486s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401740 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401740 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]