SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001439s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040185 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040185 [ RunTime:0.005741s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (809782,814670,585817,493019,129194,882608,202767,902927,113495,239020,403702,520570,213227,193984,516368,1033783,644317,659359,641507,963645,751600,952488,956688,472837,175483,1005411,16756,555299,879520,1044296,1003612,359402,367934,468779,400581,24300,304362,201781,616459,229972,341163,991166,339302,575547,520364,637261,205798,721843,479633,156169,343687,620283,882089,34252,56903,637259,391073,389990,742214,518830) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002844s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040185 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040185 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001303s ]