SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014710 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014710 [ RunTime:0.001462s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (306114,567313,359546,293150,445480,710109,359361,542013,98983,748729,591614,1010318,1021538,512599,216115,745208,4,548489,279686,232689,1026104,148986,1002894,925739,656319,155937,121019,298244,672062,301327,776294,1019046,365507,110829,672410,894355,188453,887633,950711,841701,970593,591228,11834,845349,836330,625857,510000,875693,106501,4929,256559,349942,239846,673566,150447,590696,381052,533194,968281,784827) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001881s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004128s ]