SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 119616 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 119616 [ RunTime:0.002580s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1012169,313414,235241,679975,902017,827599,722281,25734,112715,743671,43555,434627,655616,770003,632640,672051,725555,465783,1032846,82226,1010545,735957,974735,135697,850201,859461,454522,192305,231860,163135,448598,933554,149816,904831,353866,279699,805432,512036,967296,810173,27274,320889,330298,508685,440899,420223,342340,115636,503042,909190,699857,816424,737172,178880,778678,154158,991458,428329,377913,556561) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 119616 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 119616 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000461s ]