SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406203 LIMIT 1 [ RunTime:0.000539s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406203 [ RunTime:0.002347s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (406097,132357,64179,674334,746622,488778,990793,20805,860866,106754,314340,498995,89417,319772,649499,143592,410187,570833,739694,746424,579337,396942,573272,168756,638440,134117,270868,612738,129843,506347,657245,271314,925935,726300,451960,836605,76959,894028,645945,208763,140270,867155,47345,561039,704427,136190,322835,832634,605785,511122,649941,689908,431217,177364,986715,554995,540508,801238,74508,308133) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002911s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000481s ]