SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036996 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036996 [ RunTime:0.001942s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (366628,406954,363440,950574,765673,374369,490184,1035258,184004,500409,302917,988936,323860,36130,24634,237731,838742,442665,450507,676982,321244,973193,828016,665788,647820,897106,162453,650583,930137,754686,565105,783283,641346,740346,880713,849702,1000956,706863,135408,645647,31825,366097,949499,624685,562649,981470,265134,464831,1004648,886259,133399,267403,1042942,291449,531420,805914,950964,591885,316854,471318) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036996 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000596s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036996 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000802s ]