SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 333992 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 333992 [ RunTime:0.001454s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (804428,358142,105764,855382,388061,359332,984940,349097,219285,872923,781986,249581,1044808,149216,627303,372957,322658,531535,808968,193503,851871,61827,487942,848437,168230,711313,414838,380557,30828,965700,640750,74025,240401,785596,834433,744665,162852,970529,476718,596905,144813,917852,160460,213935,39888,339920,490412,136587,520363,899643,115965,775702,509139,554334,53706,217757,126049,248605,912615,589642) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 333992 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 333992 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]