SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012701 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012701 [ RunTime:0.001421s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (912052,49996,394157,695893,14952,283440,253528,293337,619306,519673,740866,7462,298410,761444,968612,990527,216763,492214,38025,575476,970895,172402,844377,122232,561286,1045347,311433,766176,152867,462101,57720,498763,726549,547264,1004925,172144,787869,310281,775739,923950,60122,1029853,365482,705891,721590,233569,973577,944593,786823,686218,360131,553287,375805,944198,781637,890251,400188,462219,754477,742563) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000948s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012701 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012701 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000422s ]