SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005721 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005721 [ RunTime:0.001802s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (848254,940310,512367,505717,260450,18308,943206,313740,260538,907514,66090,820253,734937,832972,805720,336887,265055,311890,610597,1022402,765374,930962,806045,327138,1013199,121501,508348,3430,707278,246056,358667,211680,322769,485683,1010433,488521,156388,352398,215290,241290,279644,255551,627836,399810,574813,870199,352169,407202,886567,716350,809213,828505,728293,88928,845665,1046187,1015609,593819,823355,146258) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001006s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005721 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005721 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]