SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001387s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403380 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403380 [ RunTime:0.001987s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (992040,830495,797052,345419,1020077,641942,639400,530084,7999,995884,974072,897736,192572,370680,1041913,495497,129717,195483,777144,864221,314413,826425,415199,98632,273684,228776,24483,245259,922436,758458,506513,314068,893406,965600,124034,316542,669726,105092,285405,308318,668535,149380,670041,266044,725262,659368,673963,386311,781308,272052,633689,107907,562619,527634,996487,768295,229025,139005,833852,671734) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001741s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403380 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000572s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403380 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]