SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002389s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 357311 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 357311 [ RunTime:0.002052s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (53517,880581,813127,311024,37312,872799,109318,76461,725218,555941,125578,257207,269609,1011548,399151,380167,388839,59983,345205,814586,521299,170815,45346,529714,389083,262984,530438,897079,725721,236578,427958,251082,162077,447220,928709,769197,1001458,360407,245217,164996,636595,269985,1037142,316942,483230,298870,525205,837353,487139,332251,733943,770554,600996,529641,425086,641607,573011,208655,904371,87539) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 357311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 357311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]