SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001388s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 800435 LIMIT 1 [ RunTime:0.000444s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 800435 [ RunTime:0.003182s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (583898,445191,833024,690510,19299,960363,591222,57015,986286,130369,4500,361303,142734,303631,1027943,459375,910012,256631,773184,357746,126524,727071,1047562,961009,441571,494406,704668,30410,687776,449033,81418,264508,915486,241952,397167,584917,1005363,802881,206568,491664,658668,721325,691547,859601,19918,432191,783859,881800,653546,630094,431407,162687,874264,215293,590082,497982,736409,259630,586971,441458) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 800435 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 800435 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001905s ]