SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 327813 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 327813 [ RunTime:0.002936s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (892987,804599,812809,840738,488688,1009328,275820,1013892,767249,458516,1009006,375862,714354,471821,28644,856040,875298,201739,80886,998169,865200,63123,958706,981938,239184,656062,267372,698967,877097,860873,20638,324282,28806,671897,216186,447638,293749,884480,192553,1008444,122940,968528,494230,365014,376511,831016,818037,1035099,135471,448815,658701,808902,178010,693603,993741,557316,648471,340093,181216,839538) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 327813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000973s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 327813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000464s ]