SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001462s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 874418 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 874418 [ RunTime:0.001886s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (63383,871961,182805,166083,810642,187454,670003,273857,134178,110254,120582,819010,502517,674377,370657,1022751,1015061,543491,891320,897917,460561,538840,834228,819479,254137,969092,750889,264770,359987,812341,806997,789313,25211,793820,235099,110853,798393,7922,154577,581930,742809,748861,1037336,339888,589859,102488,41514,16045,419958,868249,117219,779134,687309,489223,1027596,153482,726101,1019965,717572,261637) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 874418 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000510s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 874418 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000730s ]