SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001964s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 498290 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 498290 [ RunTime:0.001477s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (688503,816460,262071,438032,83458,280934,876408,1044750,878270,153176,836170,887678,124568,316731,671744,402873,1043841,737410,1013372,599526,519310,338297,944926,778315,367409,874849,623542,825000,12665,1002060,252859,48096,666008,754398,974745,713930,983651,775350,556783,946491,717496,680083,437696,584282,159089,1022023,782449,568958,617707,497074,868747,282092,303869,1042258,787226,597399,16556,810576,936860,21013) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000972s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 498290 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 498290 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]