SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 471271 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 471271 [ RunTime:0.001589s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (583685,438773,111164,533040,6755,254936,635886,434724,46494,678477,550885,1001780,911583,71441,850008,80835,962999,535100,501538,401490,348999,573399,453444,362763,796406,339458,728405,779334,672408,809242,160913,885330,215601,106626,1035870,468701,294002,404855,441538,483869,837905,469605,929855,51859,487739,660796,745273,448329,552881,133687,732831,354696,835051,17715,60823,484947,1025896,489323,51995,861138) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000969s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 471271 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000555s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 471271 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]