SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418919 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418919 [ RunTime:0.001590s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (199018,388227,593985,77191,691250,869224,700473,4505,20075,163758,260798,1288,699825,934562,405258,651133,877768,172899,4071,612217,343251,542839,601449,499309,804091,709227,570276,637437,37734,973481,276140,701335,548897,161506,496204,913763,810161,5912,459238,71793,539464,797655,816673,636243,828708,493604,930923,254128,486264,42441,598006,985104,893078,918439,212519,1020061,496999,766689,905065,173090) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418919 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418919 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]