SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200212 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200212 [ RunTime:0.001763s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (438261,1030420,5586,642696,412301,516897,934330,179804,439520,202485,706845,78680,43949,649624,1009488,1016314,240871,829288,328811,654304,319627,1035454,387823,654995,363304,150945,617975,1021592,556735,122623,738040,810879,736887,545256,812360,6261,588400,753797,327956,64884,1046791,312198,414848,83192,1044687,919603,103427,782582,381976,1000511,829072,641561,642873,777647,178943,144983,902381,200304,723609,654015) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001057s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200212 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200212 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]