SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413979 LIMIT 1 [ RunTime:0.001221s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413979 [ RunTime:0.003310s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1039176,446273,31252,706947,1043871,461302,19717,280500,453059,499269,633271,323231,458047,340301,966492,405713,161713,381784,612344,990588,1002748,668495,627,475079,385719,400629,387295,913125,544261,395149,179697,165321,944,347816,757350,216836,916503,4319,435952,919563,136176,494040,135225,873625,109025,490899,707900,782913,681068,783507,480520,987927,231874,695440,207118,73315,6363,41284,276684,584834) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000988s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413979 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413979 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000484s ]