SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 131227 LIMIT 1 [ RunTime:0.001528s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 131227 [ RunTime:0.001666s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (416518,1004039,201635,292438,1004200,690208,820401,113462,152737,916103,891111,223796,146443,505882,807836,938690,894162,696817,791140,510730,956709,266188,446443,1039645,300326,410922,714220,485098,241961,332827,779623,251141,1001322,285649,358918,681824,390100,467013,934233,55971,453211,802044,332410,780146,594592,170394,580451,860979,1027960,853836,521442,104743,843769,68197,622179,155097,427028,529847,67810,814250) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001942s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 131227 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 131227 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000757s ]