SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341545 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341545 [ RunTime:0.001692s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (97809,137541,187227,52522,623225,377055,299913,61449,134103,207214,343753,611515,618788,583368,885370,719326,392408,742226,59233,793323,668140,281488,272436,535034,916874,765900,189327,357379,155567,423351,400455,918614,238235,358628,366922,525253,85334,138820,537787,1004373,422616,4383,273756,727903,888055,669390,624679,879988,290194,338243,180213,404353,9282,316618,907032,999925,332350,561923,267795,605568) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002250s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341545 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341545 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000505s ]