SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 489390 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 489390 [ RunTime:0.001820s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (596159,724693,1018547,375080,1018992,55733,255331,986964,534066,881119,31391,453151,118190,312441,938649,223695,852449,195180,110155,238405,582251,1029689,283057,25889,771977,325897,101336,201137,571441,674177,418851,494157,488159,796194,629556,11613,570044,123452,614526,1017107,287404,547568,799459,543493,517982,1043347,918932,840228,502888,236008,614571,559209,583657,362487,281771,844792,528777,82659,484734,325097) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 489390 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000599s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 489390 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000431s ]