SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 336811 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 336811 [ RunTime:0.001931s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (968228,782683,513116,637110,169701,467891,458254,965624,307436,382253,589689,665166,304692,615670,826940,748357,461428,394774,805772,893611,244749,983361,5363,348986,185230,645286,205467,278107,300302,11907,972138,256340,742728,306918,471406,83628,300780,830943,721668,947684,355,898250,656707,120149,764386,1008068,117262,415396,1043385,576429,463818,524516,848492,511879,739941,457740,280507,663696,960525,820195) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 336811 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 336811 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]