SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405348 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405348 [ RunTime:0.001587s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (308046,412054,284298,904134,31629,618429,474194,622967,398058,664630,122666,611707,295997,339864,589456,398535,666492,1007909,388545,868313,451924,975626,338343,899779,300288,907849,796667,537000,24959,2258,457932,493901,249250,1005103,527731,376151,981917,950778,444946,724446,978227,392549,345418,260362,688609,943783,773166,72307,216689,54566,454199,59062,330808,1048065,775530,598613,172285,393266,489000,486733) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405348 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405348 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]