SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001352s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421391 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421391 [ RunTime:0.001676s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (296786,718611,622720,811820,862752,302481,953549,605466,20837,678392,907557,923560,242428,29231,14916,920835,1024810,866878,1045781,491630,710931,151655,23639,348078,239043,8898,302921,518025,627316,331733,732607,897941,247953,931499,607787,809316,137513,433600,39804,210346,791491,16909,791453,323891,62177,59390,1002162,489031,599919,354578,859053,204861,760304,362842,909101,1031225,409727,420010,514995,872093) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002278s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421391 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421391 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]