SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 528043 LIMIT 1 [ RunTime:0.000476s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 528043 [ RunTime:0.002792s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (924418,630724,614149,962368,808875,583626,395220,360469,707914,899529,500727,971310,683268,920638,29513,842575,489417,1031829,783976,874544,555017,1018402,969280,500547,122461,328100,106651,973359,926286,138271,1021135,537569,538321,967241,533579,156011,765688,696159,35550,593303,647625,991891,709467,751601,1007808,555789,950119,102439,367073,278388,867965,677295,747063,162368,247034,482809,394230,705847,799507,561062) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002575s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 528043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 528043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001155s ]