SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311083 LIMIT 1 [ RunTime:0.000296s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311083 [ RunTime:0.001977s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (118840,970286,719404,695248,809141,77043,71861,638406,954210,1000675,156774,857206,83377,489733,1041276,1036163,704179,913060,1022046,802778,82072,204600,67583,627908,65555,715316,366985,849083,820137,323786,790717,241286,582166,268786,40846,671229,67584,176366,460200,940376,834089,82708,710664,807740,666779,485289,546509,128915,289824,692724,156265,667590,782134,279271,155087,135532,522065,584349,408681,135203) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000418s ]