SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 526106 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 526106 [ RunTime:0.001779s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (848747,421228,808502,315441,230281,740604,870599,376469,27127,291403,766011,654779,792140,74066,66570,841426,713210,981941,76395,868129,158065,919479,640131,575494,426950,170875,162540,685992,499063,736392,490189,98763,139428,636547,303465,959012,725507,701544,724787,142767,880379,32127,470133,372994,128667,547920,409541,41409,235295,557832,366141,336337,616943,182410,953010,871416,843703,176250,131695,467286) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000987s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 526106 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 526106 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000693s ]