SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026899 LIMIT 1 [ RunTime:0.000289s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026899 [ RunTime:0.001931s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (138151,831047,967962,363029,100175,457707,173370,385782,696066,93591,266441,574832,546101,968716,201254,927822,16951,166508,866212,860277,801392,233648,464224,661785,623454,569824,511786,393524,407443,281119,369459,928768,1015342,845395,849161,561769,505703,1021422,859449,766535,798900,147446,40816,902800,614064,305211,291631,618480,932302,912863,10643,597934,427385,752965,137573,384487,72606,136567,487251,90421) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000936s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026899 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000319s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026899 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001963s ]