SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001348s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042647 LIMIT 1 [ RunTime:0.000445s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042647 [ RunTime:0.001729s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (407506,391672,178530,136418,21674,703175,362503,64702,471167,57535,146445,153615,970029,915573,1010007,390897,708994,225538,786296,539909,63098,43511,567015,422626,301393,663313,843571,273634,851597,987503,473795,870056,42443,7087,920847,371293,413320,914057,773661,603165,941528,262616,769467,507335,856145,400490,315536,782857,539824,441878,587182,364113,961198,73778,143620,446166,578220,29644,987490,817501) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000988s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042647 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042647 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000449s ]