SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 465336 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 465336 [ RunTime:0.001772s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (833074,820863,926603,832989,206355,943327,134937,873709,707646,423330,143465,116061,523514,22280,16058,401321,559995,830461,914482,490211,1028579,141853,171591,528667,912433,409984,1006888,711141,521984,455043,412723,166180,682860,612842,75216,55351,175570,703168,909260,967960,865646,814136,322195,1040687,875641,271860,313310,248754,323944,538624,858885,790575,220357,393996,501507,929070,123745,527533,236984,92969) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001834s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 465336 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000536s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 465336 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000851s ]