SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 476714 LIMIT 1 [ RunTime:0.000528s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 476714 [ RunTime:0.001524s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (279352,358816,762052,707199,177940,507296,430933,132186,1041642,572944,937286,599077,290586,150323,428470,184869,156695,793185,412212,914199,967959,595284,712921,650982,537278,719256,1046146,729192,250344,14658,933733,864398,755377,406677,965045,640668,544645,308095,267025,592033,501973,386491,16670,81342,118986,796730,307883,635267,246920,405549,165886,661790,445091,159842,110527,336200,735324,260756,697369,961396) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 476714 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 476714 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]