SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400343 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400343 [ RunTime:0.001843s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (104010,356379,395214,156051,1032462,844503,720812,460273,131771,935642,814572,417295,1002416,301432,942160,531663,310592,278196,386800,639171,437536,563316,135863,846879,928810,1042231,543495,449547,717139,207322,422468,316071,411521,1035684,868148,125652,310236,55071,128237,414203,744293,487182,678775,478965,211904,412481,264528,755893,280297,1034725,1043120,1029118,155094,1018737,524309,25462,819753,940725,624801,709772) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400343 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000522s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400343 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000384s ]