SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002839s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520372 LIMIT 1 [ RunTime:0.003702s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520372 [ RunTime:0.001712s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (372946,359110,74118,192082,191612,948052,373126,29463,425027,110997,115807,1010654,518824,626730,304582,218499,537453,137801,254933,388883,84197,652284,459144,329957,863043,494659,672257,598859,430696,498842,728528,997644,953897,799832,896988,502737,27229,553355,39833,1020381,313611,381735,157856,360078,835454,369416,585652,793829,744194,353449,732527,909110,866664,854245,315400,93311,284323,67241,180666,350254) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520372 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520372 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]