SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 910198 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 910198 [ RunTime:0.001710s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (695803,492902,675053,823081,433920,258667,461373,47211,500945,548096,961437,810134,269520,294159,465666,174473,606350,815775,151676,1048116,754519,736914,603799,799767,312513,581942,139509,531806,503131,676352,1014824,814448,273914,344754,608449,482743,154604,406897,282848,112860,784496,738466,137036,239995,979340,71366,1036652,512454,438104,941415,758991,124910,382081,324860,790496,900438,325566,711295,902540,1015762) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000975s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 910198 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 910198 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000460s ]