SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002683s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401916 LIMIT 1 [ RunTime:0.000883s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401916 [ RunTime:0.001893s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (471895,297300,292918,158650,958887,988118,277881,336217,673990,272934,353472,408036,670256,126042,788224,486127,650041,242503,280867,956821,540389,664486,38294,432878,464445,302350,972800,167861,687178,630353,539366,523252,133978,22947,321163,251225,637854,844120,636994,156045,522077,642284,547341,618183,216044,843152,375755,288061,982687,724632,151353,993611,251967,63559,300880,487831,407583,651302,83835,430766) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401916 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000701s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401916 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000476s ]