SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 436823 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 436823 [ RunTime:0.001797s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (870069,719602,432424,492352,383520,346180,331900,656594,83380,732691,813271,924069,549471,274724,629675,24370,844672,444663,118339,501472,579449,952156,966554,195715,1012224,516727,98231,37474,578562,98277,444762,478122,284481,323911,556777,433887,267174,901699,111209,967662,709386,1024561,115528,317088,1039285,650990,488335,897278,115553,46385,919283,457310,661541,75529,514590,172608,212281,809069,896983,593169) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 436823 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 436823 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]