SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026863 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026863 [ RunTime:0.002197s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (297300,148733,295221,778503,225274,277811,437204,1008583,831160,639800,272011,531690,260442,535456,619374,848278,73004,483066,627904,416744,431874,24935,575881,229314,312152,446453,280197,778531,8986,787024,316653,630813,615586,1045469,985935,502705,790802,571953,1016286,562230,850356,364655,717992,420795,911049,764347,182815,733347,538913,108349,816302,82030,74078,1021462,89430,125609,526739,150677,90566,166418) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026863 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026863 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]