SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195583 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195583 [ RunTime:0.002389s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (778072,944869,285393,653145,40094,395812,897066,340689,4011,856413,1046707,1013479,55767,376894,185260,671161,522322,884666,642922,264653,642522,999711,463954,658996,553670,997444,935970,21555,959004,335550,524713,589552,250990,176053,1010096,145151,368962,586564,975367,1011987,473374,880427,1046301,941690,855967,753652,629610,163980,50141,359098,542965,30014,266998,866660,488737,379924,694731,540429,404977,956731) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195583 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195583 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000429s ]