SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004660 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004660 [ RunTime:0.001730s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (599464,669089,891776,783035,107630,529922,642936,408942,198022,177214,55272,138184,208445,256905,935006,226262,785507,1022871,800572,518078,492372,334607,794375,985083,74716,5941,125175,383100,721307,1029311,260145,598010,216257,995236,324396,786610,933164,482746,72835,879431,880561,1002076,547336,838782,7086,609023,831537,278646,875488,297953,354129,735529,651396,764665,131211,365985,634372,118340,32103,220645) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000997s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004660 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004660 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000492s ]