SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 120143 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 120143 [ RunTime:0.001605s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (513868,549222,92002,147774,814014,566387,892408,762121,249226,662335,1000748,469834,560030,112812,31242,464997,73578,294705,24162,586058,945219,375381,773272,743887,626608,384544,51774,796998,613326,956210,927917,381858,490256,346905,406477,165271,40228,89091,2417,1018951,563613,843691,683233,804983,324204,270980,198816,718030,917854,427396,741962,291383,697211,740603,712801,569415,1038303,551472,528334,321545) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 120143 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 120143 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000505s ]