SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406457 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406457 [ RunTime:0.001406s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (981523,552761,279485,989191,806581,520317,581070,610563,66785,1045860,66548,470316,486633,151601,457852,558016,411897,921105,861706,324077,119519,378032,308109,459774,180141,691394,628079,641522,808464,888295,939673,548203,105816,158419,329457,930543,319582,644442,767342,622690,1023079,724913,263758,120371,999034,703943,84469,476995,714588,568095,182530,878337,6490,204898,726540,84730,755384,108743,696860,1008464) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406457 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406457 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000388s ]