SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 25180 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 25180 [ RunTime:0.001847s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (59214,969537,262388,910861,126301,748477,987077,38928,276870,646388,112141,269180,804183,580992,493820,901697,1007467,604294,1024546,311071,604517,787744,233678,883387,50877,613602,168195,885443,869415,803249,902352,590642,28209,924555,148868,625884,11054,896853,718438,615999,209114,771941,916165,315510,749409,164979,561484,235055,780,54965,281899,887594,777073,196913,58295,888382,218895,511003,473588,447709) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000927s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 25180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 25180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]