SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019543 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019543 [ RunTime:0.001826s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (434479,125135,539593,314805,917561,867669,964794,16862,559368,475993,1044898,925567,487259,10350,693058,891855,398536,297674,565892,841269,189840,1024821,763559,717249,159244,505925,752607,665236,822337,249256,964625,160313,610149,581866,321292,917791,213051,39465,504016,504076,224967,77597,378462,923353,476544,854887,690906,42246,220544,364740,757875,896982,462366,825552,694424,371063,737190,757909,478732,659788) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000976s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019543 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019543 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]