SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001848s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 671584 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 671584 [ RunTime:0.001865s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (486047,111981,437134,808816,110797,813978,652853,911656,1027275,3648,177436,168828,508273,377531,71563,553629,206526,842330,394841,80556,813390,350305,810035,358847,204843,367138,87221,440455,1035244,609593,674916,893997,96974,376081,648567,467755,257301,29739,276468,106397,751168,26296,599008,491555,611730,128539,69695,651349,200973,373276,542512,675277,243700,819008,177535,121947,208163,52485,481120,283729) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 671584 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000561s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 671584 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]