SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 411436 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 411436 [ RunTime:0.001721s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (998125,134715,923090,124536,541824,375789,550327,749414,358745,606936,311818,536057,151672,905353,202618,295901,503672,43711,1010291,444050,70413,140373,432200,220145,140153,233026,749128,123188,930419,896723,340915,177324,870844,618348,107291,162698,783518,122530,940075,238442,961005,792342,128424,835640,433403,1043048,605841,871655,621718,1025533,71550,905443,774535,463843,330598,607209,437287,604983,310392,368661) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 411436 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 411436 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]