SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1035694 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1035694 [ RunTime:0.001467s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (924044,466024,997196,12308,224607,297121,484121,502994,450573,685854,524236,571909,790869,729032,445862,53419,23552,999894,522915,587366,122793,285938,949460,33722,294842,229902,712707,569846,850709,615269,146714,194044,106831,911056,495875,833250,766872,345317,33873,1011782,182244,819929,800322,885171,211471,270918,363131,195149,61750,182612,872146,374455,640896,71443,849948,949335,763898,653907,646969,51820) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1035694 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1035694 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]