SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001793s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 578318 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 578318 [ RunTime:0.004099s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1036986,974359,317947,198512,742863,656328,718654,204392,824753,313400,363855,28025,413263,546266,828366,550590,838446,127646,933172,607928,357871,324257,833884,139548,704508,624076,255068,917392,516829,253970,1030229,973891,765767,439137,814464,579140,568182,703047,997602,117087,707906,683949,562413,82574,447221,19967,60825,70293,344226,222514,1023006,759587,677629,323501,175884,321869,215429,414581,308673,255276) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001993s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 578318 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 578318 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]