SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001913s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1048321 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1048321 [ RunTime:0.001955s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (772257,960500,695406,1035481,200443,998953,881549,807703,682754,750112,617434,981955,640102,708684,806185,302093,892659,345247,901246,106968,600458,91602,130178,735970,98993,11741,602308,500011,504006,517556,666078,1046861,274047,596206,648992,974288,200066,661453,239413,785446,805450,576881,1018499,286157,182564,736221,905238,515315,24189,981729,899822,862743,394385,892008,14075,801613,630619,420492,35443,160123) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1048321 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1048321 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]