SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401489 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401489 [ RunTime:0.001687s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (511564,18485,724812,718626,639991,698948,836409,549955,601096,453832,1693,330571,751004,461104,325891,269542,603950,426664,901779,907846,618767,162135,421041,528209,388794,523497,296199,359217,220250,686596,756810,132465,220878,730288,113465,716124,637788,974077,276712,29351,515507,770259,788363,281906,243192,867972,95487,1040693,476584,823921,600708,262835,280408,946573,984032,43793,895205,784236,603942,935777) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401489 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401489 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002883s ]