SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001733s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 367291 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 367291 [ RunTime:0.003155s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (425114,89636,733831,922947,262790,696986,426292,892141,728650,323409,193901,61757,2834,354473,620251,274614,606970,929505,363290,236414,623110,966983,534061,109689,46574,544937,862288,829474,793058,22842,730675,349868,143527,88841,700403,1046122,273340,864942,756254,550344,815266,1000581,888517,1041074,673706,44783,153132,313670,71367,64069,309755,284977,307037,2078,451274,829889,466742,599030,28096,1046946) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001320s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 367291 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 367291 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001438s ]