SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501188 LIMIT 1 [ RunTime:0.004115s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501188 [ RunTime:0.006060s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (533489,904349,154093,383200,600207,822332,323651,464498,714075,83688,322670,652427,344091,205265,564335,450197,200534,1026321,827395,449468,1032973,496585,963028,984077,539622,621328,523782,1046188,624361,95319,970403,530520,81370,398152,488597,553766,159580,452149,338712,561269,68937,190216,876726,881833,573672,76433,729432,280458,898615,893086,24150,533048,1032244,887076,940871,666715,1001574,253814,201763,823288) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501188 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501188 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000404s ]