SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003009s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029146 LIMIT 1 [ RunTime:0.003700s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029146 [ RunTime:0.003341s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (220606,576230,585554,844187,367455,752231,376463,606311,622847,382517,132711,518766,733997,391141,650998,324986,28157,8966,262891,640580,1257,1039647,883924,995071,533751,262493,524122,503528,991273,390515,354806,841154,429736,546569,905937,533775,758868,399060,591190,695460,257185,442559,408942,117549,79088,469252,667442,1044465,1037696,25575,2660,8026,393792,238717,52072,213884,9166,69016,555249,551177) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002092s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029146 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029146 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000798s ]