SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020354 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020354 [ RunTime:0.001584s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (296087,884666,478834,777450,138282,734601,153027,538191,659594,721522,948621,303842,298932,114168,5402,304676,294034,861270,610666,477163,646777,309438,344765,1040368,40220,860635,503990,754386,835058,112347,308054,398195,17816,963482,971055,450911,428319,950736,565829,1006549,199323,67197,300997,349997,623022,288114,582034,640559,363469,457930,946137,410109,24863,341144,477034,61966,836384,622624,794666,574068) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020354 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020354 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]