SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043401 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043401 [ RunTime:0.001861s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (527707,741962,851087,40317,291063,796946,687866,296700,740661,64478,67553,806359,145939,387330,1013364,537163,690013,173596,661515,620099,334828,219280,78099,582685,415798,941268,856760,833582,372854,432008,825137,322545,328030,841671,131757,969618,117332,23782,25568,298028,514439,868660,377416,923694,428634,841517,61792,610286,525494,452509,18260,330357,325130,509051,127770,774432,180409,710541,731033,179271) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000461s ]