SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 345928 LIMIT 1 [ RunTime:0.002402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 345928 [ RunTime:0.002125s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (492673,792102,353480,561199,115463,509208,205210,212898,691753,969827,463384,486517,262547,206489,342947,785391,934793,410330,488672,836723,333471,993305,775019,311280,567141,708856,362843,681038,411989,284463,433517,956536,321969,935351,704569,599420,71774,878964,876175,270230,923344,10306,460728,960215,380933,556843,13870,178982,984880,687154,334734,749982,966259,897175,8771,358470,873035,856657,39980,363315) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 345928 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000489s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 345928 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]