SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54950 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54950 [ RunTime:0.001809s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (348759,184869,486085,1002497,8019,717725,976639,780515,784004,651189,924302,703809,254569,928472,765540,885376,93095,846644,816351,507657,164882,884499,852724,229590,945864,247619,103467,60042,970430,70523,216774,767348,700246,168186,376177,504801,901370,1010044,33966,837316,657695,804904,944202,988038,649650,277617,915129,551674,394711,994199,920160,114090,697678,923505,890018,419785,60490,276538,408217,528855) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54950 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54950 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000703s ]