SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 518413 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 518413 [ RunTime:0.001801s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (638368,879266,1026281,952454,665153,594170,346280,316221,492354,274337,867104,183091,803925,679761,793647,122420,471558,904777,696704,1038163,1021296,690046,990887,167363,392703,60956,853458,260812,846630,990525,243534,117381,247265,126200,407308,517310,789168,543029,645753,628410,445380,357661,694150,791474,187176,1004746,981236,800464,561724,351003,218933,731508,394240,133363,744781,1036667,341618,486362,240506,211457) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 518413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 518413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]