SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001362s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 461307 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 461307 [ RunTime:0.001503s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (224890,514513,647091,212554,949632,527472,480033,484040,866463,771706,691021,1020451,242360,810212,370374,811456,984225,1002686,901061,169049,967417,632647,789350,959900,981144,347003,99625,18461,483434,935814,1030172,172499,782833,762787,468002,812612,162961,400664,569427,696365,947168,691898,328166,806005,854373,113479,301060,927962,279970,763525,360830,218074,702293,240426,74455,690450,985687,459184,34129,576475) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 461307 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 461307 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000679s ]